Teiid provides the means (i.e., Translators and JEE connectors ) to access a variety of types of data sources. The types of data sources that are currently accessible are:

1. Databases

   • Oracle

   • PostgreSQL

   • MySQL/MariaDB

   • DB2

   • Microsoft SQL Server

   • Sybase

   • Sybase IQ

   • Microsoft Access

   • Derby

   • H2

   • HSQL

   • Ingres

   • Informix

   • MetaMatrix

   • Teradata

   • Vertica

   • Generic ANSI SQL - for typical JDBC/ODBC sources

   • Simple SQL - for any JDBC/ODBC source

2. Web Services

   • SOAP

   • REST

   • Arbitrary HTTP(S)

3. OData

4. Big Data / No SQL / Search Engines / JCR and Other Sources

   • Actian Vector

   • Amazon SimpleDB

   • Apache Accumulo

   • Apache Cassandra DB

   • Apache SOLR

   • Apache Spark

   • Greenplum

   • Hive / Hadoop

   • Impala / Hadoop

   • ModeShape JCR Repository

   • Mongo DB

   • Mondrian OLAP

   • Netezza data warehouse appliance

   • Phoenix / HBase

   • PrestoDB

5. Enterprise Systems

   • OSISoft PI

   • SalesForce

   • SAP Gateway

   • SAP Hana

   • Teiid

6. Object Sources

   • JDG / Infinispan Library Mode

   • JDG / Infinispan Remote Cache Mode

   • Intersystems Cache Object Database

   • JPA sources

7. LDAP

   • RedHat Directory Server

   • Active Directory

8. Files

   • Delimited / Fixed width

   • XML

9. Spreadsheets

   • Excel

   • Google Spreadsheet

This represents data sources that have been validated to work using the available translators and connectors. However, this does not preclude a new data source from working. If a data source has a JDBC driver, Teiid can connect and easily issue SQL-92 based queries. If there is any custom SQL or functions that are needed to be supported, then an existing translator can be extended or a new translator can be created using the Translator Development extensions.

Take a look at the list of Translators that are used as the bridge between Teiid and the external system.